2025-03-05 15:59:04 Using queries from '/usr/share/clickhouse-test/queries' directory 2025-03-05 15:59:04 Connecting to ClickHouse server... OK 2025-03-05 15:59:04 Connected to server 24.3.12.76.altinitystable @ da27279116c0c6a39ac94f6f146e5eed531f6b3d HEAD 2025-03-05 15:59:04 Found 977 parallel tests and 111 sequential tests 2025-03-05 15:59:05 2025-03-05 15:59:05 Running about 122 stateless tests (ForkPoolWorker-8). 2025-03-05 15:59:05 2025-03-05 15:59:05 03151_pmj_join_non_procssed_clash: [ OK ] 0.83 sec. 2025-03-05 15:59:05 2025-03-05 15:59:05 Running about 122 stateless tests (ForkPoolWorker-7). 2025-03-05 15:59:05 2025-03-05 15:59:05 03152_analyzer_columns_list: [ OK ] 0.95 sec. 2025-03-05 15:59:05 2025-03-05 15:59:05 Running about 122 stateless tests (ForkPoolWorker-4). 2025-03-05 15:59:05 2025-03-05 15:59:05 03203_system_numbers_limit_and_offset_complex: [ OK ] 0.99 sec. 2025-03-05 15:59:05 2025-03-05 15:59:05 Running about 122 stateless tests (ForkPoolWorker-9). 2025-03-05 15:59:05 2025-03-05 15:59:05 03143_parallel_replicas_mat_view_bug: [ OK ] 0.95 sec. 2025-03-05 15:59:05 2025-03-05 15:59:05 Running about 122 stateless tests (ForkPoolWorker-3). 2025-03-05 15:59:05 2025-03-05 15:59:05 03217_filtering_in_storage_merge: [ OK ] 0.97 sec. 2025-03-05 15:59:06 2025-03-05 15:59:06 Running about 122 stateless tests (ForkPoolWorker-6). 2025-03-05 15:59:06 2025-03-05 15:59:06 03164_analyzer_validate_tree_size: [ OK ] 1.59 sec. 2025-03-05 15:59:06 03129_cte_with_final: [ OK ] 0.80 sec. 2025-03-05 15:59:06 03031_input_format_allow_errors_num_bad_escape_sequence: [ OK ] 0.65 sec. 2025-03-05 15:59:06 03023_remove_unused_column_distinct: [ OK ] 0.65 sec. 2025-03-05 15:59:06 03038_move_partition_to_oneself_deadlock: [ OK ] 0.86 sec. 2025-03-05 15:59:06 2025-03-05 15:59:06 Running about 122 stateless tests (ForkPoolWorker-2). 2025-03-05 15:59:06 2025-03-05 15:59:06 03222_datetime64_small_value_const: [ OK ] 2.12 sec. 2025-03-05 15:59:06 03033_analyzer_resolve_from_parent_scope: [ OK ] 1.17 sec. 2025-03-05 15:59:06 03019_numbers_pretty: [ OK ] 0.73 sec. 2025-03-05 15:59:06 03007_column_nullable_uninitialzed_value: [ OK ] 0.59 sec. 2025-03-05 15:59:06 03018_analyzer_distributed_query_with_positional_arguments: [ OK ] 0.77 sec. 2025-03-05 15:59:07 03010_view_prewhere_in: [ OK ] 0.76 sec. 2025-03-05 15:59:07 03006_buffer_overflow_join: [ OK ] 0.73 sec. 2025-03-05 15:59:07 03003_compatibility_setting_bad_value: [ OK ] 0.53 sec. 2025-03-05 15:59:07 03002_map_array_functions_with_low_cardinality: [ OK ] 0.64 sec. 2025-03-05 15:59:07 03002_analyzer_prewhere: [ OK ] 0.94 sec. 2025-03-05 15:59:08 03006_mv_deduplication_throw_if_async_insert: [ OK ] 1.33 sec. 2025-03-05 15:59:08 02999_scalar_subqueries_bug_2: [ OK ] 0.71 sec. 2025-03-05 15:59:08 02997_projections_formatting: [ OK ] 0.66 sec. 2025-03-05 15:59:08 2025-03-05 15:59:08 Running about 122 stateless tests (ForkPoolWorker-5). 2025-03-05 15:59:08 2025-03-05 15:59:08 03198_settings_in_csv_tsv_schema_cache: [ OK ] 3.92 sec. 2025-03-05 15:59:08 02995_preliminary_filters_duplicated_columns: [ OK ] 0.69 sec. 2025-03-05 15:59:09 02995_bad_formatting_union_intersect: [ OK ] 0.79 sec. 2025-03-05 15:59:09 02990_format_not_precedence: [ OK ] 0.80 sec. 2025-03-05 15:59:09 02988_join_using_prewhere_pushdown: [ OK ] 0.93 sec. 2025-03-05 15:59:09 02985_if_over_big_int_decimal: [ OK ] 1.01 sec. 2025-03-05 15:59:09 03001_bad_error_message_higher_order_functions: [ OK ] 2.56 sec. 2025-03-05 15:59:09 02982_unambiguous_alter_commands: [ OK ] 0.97 sec. 2025-03-05 15:59:10 02982_parallel_replicas_unexpected_cluster: [ OK ] 1.23 sec. 2025-03-05 15:59:10 02981_variant_type_function: [ OK ] 1.43 sec. 2025-03-05 15:59:10 02973_dictionary_table_exception_fix: [ OK ] 0.97 sec. 2025-03-05 15:59:11 02971_limit_by_distributed: [ OK ] 1.04 sec. 2025-03-05 15:59:11 02968_analyzer_join_column_not_found: [ OK ] 0.88 sec. 2025-03-05 15:59:11 02975_intdiv_with_decimal: [ OK ] 2.08 sec. 2025-03-05 15:59:12 02967_index_hint_crash: [ OK ] 0.87 sec. 2025-03-05 15:59:12 02968_mysql_prefer_column_name_to_alias: [ OK ] 1.59 sec. 2025-03-05 15:59:12 03020_output_format_client: [ OK ] 6.34 sec. 2025-03-05 15:59:12 02967_analyzer_fuzz: [ OK ] 1.14 sec. 2025-03-05 15:59:13 02962_indexHint_rpn_construction: [ OK ] 0.76 sec. 2025-03-05 15:59:13 02959_system_database_engines: [ OK ] 0.63 sec. 2025-03-05 15:59:13 02962_analyzer_constant_set: [ OK ] 0.81 sec. 2025-03-05 15:59:13 02963_test_flexible_disk_configuration: [ OK ] 1.78 sec. 2025-03-05 15:59:13 02954_analyzer_fuzz_i57086: [ OK ] 0.82 sec. 2025-03-05 15:59:14 02974_backup_query_format_null: [ OK ] 4.28 sec. 2025-03-05 15:59:14 02949_ttl_group_by_bug: [ OK ] 0.94 sec. 2025-03-05 15:59:14 03001_backup_matview_after_modify_query: [ OK ] 7.24 sec. 2025-03-05 15:59:14 02950_reading_array_tuple_subcolumns: [ OK ] 1.78 sec. 2025-03-05 15:59:14 02947_dropped_tables_parts: [ OK ] 0.87 sec. 2025-03-05 15:59:15 02949_parallel_replicas_in_subquery: [ OK ] 1.85 sec. 2025-03-05 15:59:15 02935_ipv6_bit_operations: [ OK ] 0.72 sec. 2025-03-05 15:59:16 02950_part_log_bytes_uncompressed: [ OK ] 2.92 sec. 2025-03-05 15:59:16 02933_compare_with_bool_as_string: [ OK ] 0.61 sec. 2025-03-05 15:59:16 02943_order_by_all: [ OK ] 1.98 sec. 2025-03-05 15:59:16 02943_tokenbf_and_ngrambf_indexes_support_match_function: [ OK ] 1.91 sec. 2025-03-05 15:59:17 02931_alter_materialized_view_query_inconsistent: [ OK ] 0.89 sec. 2025-03-05 15:59:17 02950_parallel_replicas_used_count: [ OK ] 4.26 sec. 2025-03-05 15:59:17 02932_query_settings_max_size_drop: [ OK ] 1.87 sec. 2025-03-05 15:59:18 02981_vertical_merges_memory_usage: [ OK ] 8.87 sec. 2025-03-05 15:59:18 02931_size_virtual_column_use_structure_from_insertion_table: [ OK ] 2.13 sec. 2025-03-05 15:59:18 02916_distributed_skip_unavailable_shards: [ OK ] 1.00 sec. 2025-03-05 15:59:19 02918_gorilla_invalid_file: [ OK ] 1.81 sec. 2025-03-05 15:59:19 02916_csv_infer_numbers_from_strings: [ OK ] 0.69 sec. 2025-03-05 15:59:19 02933_replicated_database_forbid_create_as_select: [ OK ] 4.32 sec. 2025-03-05 15:59:19 02915_analyzer_fuzz_5: [ OK ] 0.81 sec. 2025-03-05 15:59:20 02911_analyzer_explain_estimate: [ OK ] 0.75 sec. 2025-03-05 15:59:21 02915_sleep_large_uint: [ OK ] 1.81 sec. 2025-03-05 15:59:21 02921_file_engine_size_virtual_column: [ OK ] 4.03 sec. 2025-03-05 15:59:21 02932_punycode: [ OK ] 5.43 sec. 2025-03-05 15:59:21 02915_fpc_overflow: [ OK ] 2.35 sec. 2025-03-05 15:59:22 02903_bug_43644: [ OK ] 0.91 sec. 2025-03-05 15:59:22 02902_select_subcolumns_from_engine_null: [ OK ] 0.71 sec. 2025-03-05 15:59:22 02900_window_function_with_sparse_column: [ OK ] 0.87 sec. 2025-03-05 15:59:22 02901_remove_nullable_crash_analyzer: [ OK ] 1.03 sec. 2025-03-05 15:59:22 02907_fromDaysSinceYearZero: [ OK ] 2.51 sec. 2025-03-05 15:59:23 02898_parallel_replicas_custom_key_final: [ OK ] 1.09 sec. 2025-03-05 15:59:23 02890_describe_table_options: [ OK ] 1.01 sec. 2025-03-05 15:59:24 02890_untuple_column_names: [ OK ] 1.56 sec. 2025-03-05 15:59:25 02897_alter_partition_parameters: [ OK ] 2.94 sec. 2025-03-05 15:59:25 02884_parquet_new_encodings: [ OK ] 2.08 sec. 2025-03-05 15:59:25 02884_string_distance_function: [ OK ] 2.39 sec. 2025-03-05 15:59:26 02908_Npy_files_caching: [ OK ] 6.15 sec. 2025-03-05 15:59:26 02876_json_incomplete_types_as_strings_inference: [ OK ] 1.48 sec. 2025-03-05 15:59:27 02883_array_scalar_mult_div_modulo: [ OK ] 2.65 sec. 2025-03-05 15:59:27 02872_prewhere_filter: [ OK ] 1.67 sec. 2025-03-05 15:59:27 02871_multiple_joins_rewriter_v2_handle_last_table_columns: [ OK ] 1.58 sec. 2025-03-05 15:59:29 02871_join_on_system_errors: [ OK ] 1.52 sec. 2025-03-05 15:59:29 02868_operator_is_not_distinct_from_priority: [ OK ] 1.55 sec. 2025-03-05 15:59:30 02871_clickhouse_client_restart_pager: [ OK ] 3.60 sec. 2025-03-05 15:59:30 02916_replication_protocol_wait_for_part: [ OK ] 12.58 sec. 2025-03-05 15:59:31 02867_null_lc_in_bug: [ OK ] 2.64 sec. 2025-03-05 15:59:34 02862_sorted_distinct_sparse_fix: [ OK ] 3.06 sec. 2025-03-05 15:59:34 02876_yyyymmddtodate: [ OK ] 9.16 sec. 2025-03-05 15:59:34 02860_distributed_flush_on_detach: [ OK ] 3.39 sec. 2025-03-05 15:59:35 02864_statistic_exception: [ OK ] 6.15 sec. 2025-03-05 15:59:35 02883_zookeeper_finalize_stress: [ OK ] 11.93 sec. 2025-03-05 15:59:36 02845_domain_rfc_support_ipv6: [ OK ] 1.75 sec. 2025-03-05 15:59:36 02843_date_predicate_optimizations_bugs: [ OK ] 0.81 sec. 2025-03-05 15:59:37 02842_filesystem_cache_validate_path: [ OK ] 0.94 sec. 2025-03-05 15:59:37 02843_context_has_expired: [ OK ] 1.57 sec. 2025-03-05 15:59:38 02833_sparse_columns_tuple_function: [ OK ] 0.93 sec. 2025-03-05 15:59:38 02844_table_function_url_filter_by_virtual_columns: [ OK ] 3.17 sec. 2025-03-05 15:59:38 02864_restore_table_with_broken_part: [ OK ] 8.27 sec. 2025-03-05 15:59:38 02832_transform_fixed_string_no_default: [ OK ] 0.73 sec. 2025-03-05 15:59:38 02814_create_index_uniq_noop: [ OK ] 0.55 sec. 2025-03-05 15:59:39 02833_tuple_concat: [ OK ] 1.45 sec. 2025-03-05 15:59:39 02814_ReplacingMergeTree_fix_select_final_on_single_partition: [ OK ] 1.15 sec. 2025-03-05 15:59:39 02845_parquet_odd_decimals: [ OK ] 4.33 sec. 2025-03-05 15:59:39 02842_table_function_file_filter_by_virtual_columns: [ OK ] 2.73 sec. 2025-03-05 15:59:40 02810_row_binary_with_defaults: [ OK ] 0.79 sec. 2025-03-05 15:59:40 02811_invalid_embedded_rocksdb_create: [ OK ] 1.37 sec. 2025-03-05 15:59:41 02812_pointwise_array_operations: [ OK ] 2.69 sec. 2025-03-05 15:59:41 02813_seriesOutliersDetectTukey: [ OK ] 3.01 sec. 2025-03-05 15:59:42 02809_prewhere_and_in: [ OK ] 1.58 sec. 2025-03-05 15:59:42 02811_primary_key_in_columns: [ OK ] 2.94 sec. 2025-03-05 15:59:43 02792_drop_projection_lwd: [ OK ] 1.23 sec. 2025-03-05 15:59:43 02811_csv_input_field_type_mismatch: [ OK ] 4.33 sec. 2025-03-05 15:59:43 02789_functions_after_sorting_and_columns_with_same_names_bug: [ OK ] 1.11 sec. 2025-03-05 15:59:43 02789_jit_cannot_convert_column: [ OK ] 0.68 sec. 2025-03-05 15:59:44 02787_transform_null: [ OK ] 0.87 sec. 2025-03-05 15:59:44 02790_client_max_opening_fd: [ OK ] 2.23 sec. 2025-03-05 15:59:45 02785_global_join_too_many_columns: [ OK ] 1.12 sec. 2025-03-05 15:59:45 02785_left_anti_join_bug: [ OK ] 1.46 sec. 2025-03-05 15:59:45 02784_projections_read_in_order_bug: [ OK ] 1.06 sec. 2025-03-05 15:59:45 02803_backup_tmp_files: [ OK ] 4.07 sec. 2025-03-05 15:59:46 02783_parsedatetimebesteffort_syslog: [ FAIL ] 0.91 sec. - result differs with reference: 2025-03-05 15:59:46 --- /usr/share/clickhouse-test/queries/0_stateless/02783_parsedatetimebesteffort_syslog.reference 2025-03-05 15:54:04.956504676 -0400 2025-03-05 15:59:46 +++ /tmp/clickhouse-test/0_stateless/02783_parsedatetimebesteffort_syslog.stdout 2025-03-05 15:59:45.965124099 -0400 2025-03-05 15:59:46 @@ -23,15 +23,15 @@ 2025-03-05 15:59:46 Row 1: 2025-03-05 15:59:46 ────── 2025-03-05 15:59:46 syslog_arg: Jul 1 23:59:30 2025-03-05 15:59:46 -res: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res_null: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res_zero: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res_us: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res_us_null: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res_us_zero: 2022-06-30 23:59:30 2025-03-05 15:59:46 -res64: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 -res64_null: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 -res64_zero: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 -res64_us: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 -res64_us_null: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 -res64_us_zero: 2022-06-30 23:59:30.000 2025-03-05 15:59:46 +res: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res_null: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res_zero: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res_us: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res_us_null: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res_us_zero: 2022-07-01 23:59:30 2025-03-05 15:59:46 +res64: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 +res64_null: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 +res64_zero: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 +res64_us: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 +res64_us_null: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 +res64_us_zero: 2022-07-01 23:59:30.000 2025-03-05 15:59:46 2025-03-05 15:59:46 2025-03-05 15:59:46 Settings used in the test: --max_insert_threads 7 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11906958 --max_read_buffer_size 641494 --prefer_localhost_replica 0 --max_block_size 23331 --max_threads 25 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 34518637 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 17 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 1 --max_bytes_before_remerge_sort 2977142357 --min_compress_block_size 1659244 --max_compress_block_size 1378900 --merge_tree_compact_parts_min_granules_to_multibuffer_read 114 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 8287430 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Grenada --prefer_warmed_unmerged_parts_seconds 5 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.54 2025-03-05 15:59:46 2025-03-05 15:59:46 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 2538038412 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 11308957 --merge_max_block_size 11628 --index_granularity 34416 --min_bytes_for_wide_part 405337298 --marks_compress_block_size 62604 --primary_key_compress_block_size 76275 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 2936785 --compact_parts_max_bytes_to_buffer 116936010 --compact_parts_max_granules_to_buffer 198 --compact_parts_merge_max_bytes_to_prefetch_part 23790688 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 30 2025-03-05 15:59:46 2025-03-05 15:59:46 Database: test_y6abek8j 2025-03-05 15:59:46 02771_if_constant_folding: [ OK ] 0.62 sec. 2025-03-05 15:59:47 02764_index_analysis_fix: [ OK ] 0.80 sec. 2025-03-05 15:59:47 02766_bitshift_with_const_arguments: [ OK ] 1.43 sec. 2025-03-05 15:59:48 02782_avro_decimals: [ OK ] 2.60 sec. 2025-03-05 15:59:48 02764_parallel_replicas_plain_merge_tree: [ OK ] 1.16 sec. 2025-03-05 15:59:50 02845_threads_count_in_distributed_queries: [ OK ] 19.29 sec. 2025-03-05 15:59:50 02752_space_function: [ OK ] 2.61 sec. 2025-03-05 15:59:51 02751_protobuf_ipv6: [ OK ] 2.85 sec. 2025-03-05 15:59:51 02784_disable_async_with_dedup_correctly: [ OK ] 6.57 sec. 2025-03-05 15:59:51 02746_index_analysis_binary_operator_with_null: [ OK ] 0.94 sec. 2025-03-05 15:59:52 02735_array_map_array_of_tuples: [ OK ] 0.79 sec. 2025-03-05 15:59:52 02734_sparse_columns_short_circuit: [ OK ] 1.15 sec. 2025-03-05 15:59:53 02731_nothing_deserialization: [ OK ] 0.87 sec. 2025-03-05 15:59:54 02725_object_column_alter: [ OK ] 1.09 sec. 2025-03-05 15:59:55 02730_with_fill_by_sorting_prefix: [ OK ] 2.41 sec. 2025-03-05 15:59:55 02731_replace_partition_from_temporary_table: [ OK ] 4.03 sec. 2025-03-05 15:59:56 02725_any_join_single_row: [ OK ] 1.80 sec. 2025-03-05 15:59:56 02724_persist_interval_type: [ OK ] 1.18 sec. 2025-03-05 15:59:56 02751_text_formats_bad_nullable_parsing: [ OK ] 6.21 sec. 2025-03-05 15:59:57 02810_async_insert_dedup_replicated_collapsing: [ OK ] 16.79 sec. 2025-03-05 15:59:57 02720_row_policy_column_with_dots: [ OK ] 0.98 sec. 2025-03-05 15:59:57 02715_or_null: [ OK ] 0.80 sec. 2025-03-05 15:59:57 02714_date_date32_in: [ OK ] 0.67 sec. 2025-03-05 15:59:58 02723_param_exception_message_context: [ OK ] 2.46 sec. 2025-03-05 15:59:58 02707_analyzer_nested_lambdas_types: [ OK ] 0.84 sec. 2025-03-05 15:59:58 02711_server_uuid_macro: [ OK ] 1.48 sec. 2025-03-05 15:59:59 02701_invalid_having_NOT_AN_AGGREGATE: [ OK ] 0.73 sec. 2025-03-05 15:59:59 02699_polygons_sym_difference_rollup: [ OK ] 0.93 sec. 2025-03-05 16:00:00 02696_ignore_inacc_tables_mat_view_atttach: [ OK ] 1.22 sec. 2025-03-05 16:00:01 02705_settings_check_changed_flag: [ OK ] 2.65 sec. 2025-03-05 16:00:01 02710_protobuf_ipv4_date32: [ OK ] 3.54 sec. 2025-03-05 16:00:01 02695_logical_optimizer_alias_bug: [ OK ] 1.36 sec. 2025-03-05 16:00:01 02693_multiple_joins_in: [ OK ] 0.87 sec. 2025-03-05 16:00:02 02687_native_fuzz: [ OK ] 0.83 sec. 2025-03-05 16:00:02 02680_datetime64_monotonic_check: [ OK ] 1.58 sec. 2025-03-05 16:00:03 02679_query_parameters_dangling_pointer: [ OK ] 1.17 sec. 2025-03-05 16:00:03 02680_illegal_type_of_filter_projection: [ OK ] 1.50 sec. 2025-03-05 16:00:03 02678_explain_pipeline_graph_with_projection: [ OK ] 1.42 sec. 2025-03-05 16:00:04 02675_grant_query_formatting: [ OK ] 1.83 sec. 2025-03-05 16:00:06 02714_async_inserts_empty_data: [ OK ] 9.08 sec. 2025-03-05 16:00:07 02597_column_delete_and_replication: [ OK ] 2.74 sec. 2025-03-05 16:00:09 02784_parallel_replicas_automatic_decision: [ OK ] 24.98 sec. 2025-03-05 16:00:10 02594_msgpack_more_types: [ OK ] 2.81 sec. 2025-03-05 16:00:11 02595_orc_arrow_parquet_more_types: [ OK ] 5.00 sec. 2025-03-05 16:00:11 02582_async_reading_with_small_limit: [ OK ] 0.90 sec. 2025-03-05 16:00:12 02582_analyzer_join_subquery_empty_column_list: [ OK ] 1.10 sec. 2025-03-05 16:00:12 02584_compressor_codecs: [ OK ] 2.77 sec. 2025-03-05 16:00:13 02579_fill_empty_chunk_analyzer: [ OK ] 0.65 sec. 2025-03-05 16:00:13 02578_ipv4_codec_t64: [ OK ] 0.83 sec. 2025-03-05 16:00:15 02575_merge_prewhere_materialized: [ OK ] 1.34 sec. 2025-03-05 16:00:15 02581_width_bucket: [ OK ] 3.11 sec. 2025-03-05 16:00:16 02941_variant_type_4: [ OK ] 61.03 sec. 2025-03-05 16:00:16 02575_map_hashing_msan: [ OK ] 1.03 sec. 2025-03-05 16:00:16 02572_max_intersections: [ OK ] 0.63 sec. 2025-03-05 16:00:16 02574_suspicious_low_cardinality_msan: [ OK ] 1.30 sec. 2025-03-05 16:00:18 02565_analyzer_limit_settings: [ OK ] 1.65 sec. 2025-03-05 16:00:20 02571_local_desc_abort_on_twitter_json: [ OK ] 3.64 sec. 2025-03-05 16:00:21 02581_share_big_sets_between_mutation_tasks_with_storage_set: [ OK ] 9.59 sec. 2025-03-05 16:00:22 02567_native_type_conversions: [ OK ] 6.01 sec. 2025-03-05 16:00:23 02560_window_ntile: [ OK ] 2.23 sec. 2025-03-05 16:00:24 02560_count_digits: [ OK ] 1.23 sec. 2025-03-05 16:00:26 02556_local_with_totals_and_extremes: [ OK ] 2.22 sec. 2025-03-05 16:00:28 02561_sorting_constants_and_distinct_crash: [ OK ] 8.71 sec. 2025-03-05 16:00:29 02561_temporary_table_grants: [ OK ] 10.59 sec. 2025-03-05 16:00:29 02552_client_format_settings: [ OK ] 0.70 sec. 2025-03-05 16:00:30 02541_empty_function_support_ip: [ OK ] 0.84 sec. 2025-03-05 16:00:31 02539_generate_random_ip: [ OK ] 0.74 sec. 2025-03-05 16:00:31 02661_read_from_archive_targz: [ OK ] 28.41 sec. 2025-03-05 16:00:32 02661_read_from_archive_tzst: [ OK ] 29.18 sec. 2025-03-05 16:00:33 02661_read_from_archive_tar: [ OK ] 29.46 sec. 2025-03-05 16:00:33 02536_date_from_number_inference_fix: [ OK ] 0.69 sec. 2025-03-05 16:00:33 02538_alter_rename_sequence: [ OK ] 1.79 sec. 2025-03-05 16:00:33 02535_analyzer_limit_offset: [ OK ] 0.66 sec. 2025-03-05 16:00:34 02524_fuzz_and_fuss: [ OK ] 0.69 sec. 2025-03-05 16:00:34 02534_join_prewhere_bug: [ OK ] 1.48 sec. 2025-03-05 16:00:34 02526_kv_engine_different_filter_type: [ OK ] 1.23 sec. 2025-03-05 16:00:35 02522_different_types_in_storage_merge: [ OK ] 0.88 sec. 2025-03-05 16:00:35 02539_vertical_merge_compact_parts: [ OK ] 4.14 sec. 2025-03-05 16:00:35 02560_vertical_merge_memory_usage: [ OK ] 12.16 sec. 2025-03-05 16:00:35 02517_uuid_parsing: [ OK ] 0.88 sec. 2025-03-05 16:00:36 02515_tuple_lambda_parsing: [ OK ] 0.52 sec. 2025-03-05 16:00:36 02514_tsv_zero_started_number: [ OK ] 0.65 sec. 2025-03-05 16:00:36 02507_to_unix_timestamp_overflow: [ OK ] 0.82 sec. 2025-03-05 16:00:37 02504_disallow_arrayjoin_in_mutations: [ OK ] 1.01 sec. 2025-03-05 16:00:37 02503_in_lc_const_args_bug: [ OK ] 0.75 sec. 2025-03-05 16:00:37 02503_join_switch_alias_fuzz: [ OK ] 0.68 sec. 2025-03-05 16:00:37 02499_escaped_quote_schema_inference: [ OK ] 0.59 sec. 2025-03-05 16:00:38 02499_analyzer_set_index: [ OK ] 1.05 sec. 2025-03-05 16:00:39 02498_random_string_in_json_schema_inference: [ OK ] 2.11 sec. 2025-03-05 16:00:41 02496_row_binary_large_string_size: [ OK ] 3.16 sec. 2025-03-05 16:00:42 02494_array_function_range: [ OK ] 0.97 sec. 2025-03-05 16:00:42 02495_concat_with_separator: [ OK ] 3.18 sec. 2025-03-05 16:00:44 02498_storage_join_key_positions: [ OK ] 6.48 sec. 2025-03-05 16:00:44 02493_analyzer_table_functions_untuple: [ OK ] 1.47 sec. 2025-03-05 16:00:47 02516_projections_with_rollup: [ OK ] 11.84 sec. 2025-03-05 16:00:48 02493_inconsistent_hex_and_binary_number: [ OK ] 6.16 sec. 2025-03-05 16:00:48 02487_create_index_normalize_functions: [ OK ] 1.21 sec. 2025-03-05 16:00:49 02555_davengers_rename_chain: [ OK ] 22.85 sec. 2025-03-05 16:00:49 02482_execute_functions_before_sorting_bug: [ OK ] 0.87 sec. 2025-03-05 16:00:49 02550_client_connections_credentials: [ OK ] 20.57 sec. 2025-03-05 16:00:50 02481_default_value_used_in_row_level_filter: [ OK ] 1.19 sec. 2025-03-05 16:00:50 02479_if_with_null_and_cullable_const: [ OK ] 0.81 sec. 2025-03-05 16:00:50 02480_analyzer_alias_nullptr: [ OK ] 1.05 sec. 2025-03-05 16:00:50 02493_max_streams_for_merge_tree_reading: [ OK ] 6.51 sec. 2025-03-05 16:00:51 02764_csv_trim_whitespaces: [ OK ] 64.16 sec. 2025-03-05 16:00:51 02479_nullable_primary_key_non_first_column: [ OK ] 1.08 sec. 2025-03-05 16:00:51 02477_logical_expressions_optimizer_low_cardinality: [ OK ] 1.02 sec. 2025-03-05 16:00:52 02490_replacing_merge_tree_is_deleted_column: [ OK ] 8.17 sec. 2025-03-05 16:00:53 02477_age_datetime64: [ OK ] 2.50 sec. 2025-03-05 16:00:53 02476_query_parameters_without_serialisation: [ OK ] 1.30 sec. 2025-03-05 16:00:53 02477_age: [ OK ] 2.75 sec. 2025-03-05 16:00:53 02475_analyzer_join_tree_subquery: [ OK ] 0.76 sec. 2025-03-05 16:00:54 02474_extract_fixedstring_from_json: [ OK ] 0.86 sec. 2025-03-05 16:00:54 02456_aggregate_state_conversion: [ OK ] 0.76 sec. 2025-03-05 16:00:55 02470_suspicious_low_cardinality_msan: [ OK ] 1.64 sec. 2025-03-05 16:00:56 02455_extract_fixed_string_from_nested_json: [ OK ] 0.90 sec. 2025-03-05 16:00:56 02456_alter-nullable-column-bag: [ OK ] 1.06 sec. 2025-03-05 16:00:56 02457_tuple_of_intervals: [ OK ] 2.94 sec. 2025-03-05 16:00:57 02477_invalid_reads: [ OK ] 5.51 sec. 2025-03-05 16:00:57 02436_system_zookeeper_context: [ OK ] 1.05 sec. 2025-03-05 16:00:57 02477_s3_request_throttler: [ OK ] 6.25 sec. 2025-03-05 16:00:57 02454_set_parameters_formatting: [ OK ] 1.74 sec. 2025-03-05 16:00:57 02429_combinators_in_array_reduce: [ OK ] 0.79 sec. 2025-03-05 16:00:59 02429_low_cardinality_trash: [ OK ] 1.73 sec. 2025-03-05 16:00:59 02428_delete_with_settings: [ OK ] 1.74 sec. 2025-03-05 16:01:00 02428_index_analysis_with_null_literal: [ OK ] 2.36 sec. 2025-03-05 16:01:00 02426_pod_array_overflow_3: [ OK ] 0.74 sec. 2025-03-05 16:01:00 02428_combinators_with_over_statement: [ OK ] 1.22 sec. 2025-03-05 16:01:02 02426_orc_bug: [ OK ] 2.21 sec. 2025-03-05 16:01:03 02422_insert_different_granularity: [ OK ] 3.10 sec. 2025-03-05 16:01:04 02418_keeper_map_keys_limit: [ OK ] 1.98 sec. 2025-03-05 16:01:04 02414_all_new_table_functions_must_be_documented: [ OK ] 0.76 sec. 2025-03-05 16:01:05 02408_to_fixed_string_short_circuit: [ OK ] 0.84 sec. 2025-03-05 16:01:05 02402_merge_engine_with_view: [ OK ] 1.10 sec. 2025-03-05 16:01:08 02400_memory_accounting_on_error: [ OK ] 3.25 sec. 2025-03-05 16:01:09 02444_async_broken_outdated_part_loading: [ OK ] 12.95 sec. 2025-03-05 16:01:09 02383_schema_inference_hints: [ OK ] 0.74 sec. 2025-03-05 16:01:09 02521_tsv_csv_custom_header_detection: [ OK ] 34.97 sec. 2025-03-05 16:01:10 02383_array_signed_const_positive_index: [ OK ] 1.54 sec. 2025-03-05 16:01:10 02381_analyzer_join_final: [ OK ] 1.29 sec. 2025-03-05 16:01:12 02381_join_dup_columns_in_plan: [ OK ] 3.10 sec. 2025-03-05 16:01:13 02377_optimize_sorting_by_input_stream_properties: [ OK ] 2.35 sec. 2025-03-05 16:01:13 02377_modify_column_from_lc: [ OK ] 2.64 sec. 2025-03-05 16:01:14 02376_analyzer_in_function_subquery: [ OK ] 2.18 sec. 2025-03-05 16:01:15 02374_analyzer_array_join: [ OK ] 2.28 sec. 2025-03-05 16:01:16 02372_now_in_block: [ OK ] 1.62 sec. 2025-03-05 16:01:17 02370_analyzer_in_function: [ OK ] 1.81 sec. 2025-03-05 16:01:19 02366_kql_mvexpand: [ OK ] 1.76 sec. 2025-03-05 16:01:20 02364_window_case: [ OK ] 0.69 sec. 2025-03-05 16:01:25 02366_kql_func_ip: [ OK ] 9.14 sec. 2025-03-05 16:01:25 02361_fsync_profile_events: [ OK ] 5.78 sec. 2025-03-05 16:01:27 02373_datetime64_monotonicity: [ OK ] 13.66 sec. 2025-03-05 16:01:29 02358_file_default_value: [ OK ] 3.25 sec. 2025-03-05 16:01:29 02354_parse_timedelta: [ OK ] 3.35 sec. 2025-03-05 16:01:30 02354_vector_search_default_granularity: [ OK ] 1.61 sec. 2025-03-05 16:01:31 02353_isnullable: [ OK ] 0.83 sec. 2025-03-05 16:01:33 02351_Map_combinator_dist: [ OK ] 2.07 sec. 2025-03-05 16:01:34 02354_vector_search_queries: [ FAIL ] 5.09 sec. - result differs with reference: 2025-03-05 16:01:34 --- /usr/share/clickhouse-test/queries/0_stateless/02354_vector_search_queries.reference 2025-03-05 15:54:04.896504211 -0400 2025-03-05 16:01:34 +++ /tmp/clickhouse-test/0_stateless/02354_vector_search_queries.stdout 2025-03-05 16:01:34.228259955 -0400 2025-03-05 16:01:34 @@ -16,7 +16,7 @@ 2025-03-05 16:01:34 6 [0,2.1] 0.09999990463256836 2025-03-05 16:01:34 7 [0,2.2] 0.20000004768371582 2025-03-05 16:01:34 - Annoy: WHERE-type, EXPLAIN 2025-03-05 16:01:34 -Expression ((Projection + Before ORDER BY)) 2025-03-05 16:01:34 +Expression ((Project names + Projection)) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Expression 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_annoy) 2025-03-05 16:01:34 @@ -25,29 +25,19 @@ 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 1/1 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: annoy GRANULARITY 100000000 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/1 2025-03-05 16:01:34 - Annoy: ORDER-BY-type, EXPLAIN 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_annoy) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 1/1 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: annoy GRANULARITY 100000000 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/1 2025-03-05 16:01:34 - Usearch: WHERE-type, EXPLAIN 2025-03-05 16:01:34 -Expression ((Projection + Before ORDER BY)) 2025-03-05 16:01:34 +Expression ((Project names + Projection)) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Expression 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_usearch) 2025-03-05 16:01:34 @@ -56,27 +46,17 @@ 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 1/1 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: usearch GRANULARITY 100000000 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/1 2025-03-05 16:01:34 - Usearch: ORDER-BY-type, EXPLAIN 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_usearch) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 1/1 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: usearch GRANULARITY 100000000 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/1 2025-03-05 16:01:34 ARRAY vectors, 12 rows, index_granularity = 3, GRANULARITY = 2 --> 4 granules, 2 indexed block 2025-03-05 16:01:34 - Annoy: WHERE-type 2025-03-05 16:01:34 6 [0,2] 0 2025-03-05 16:01:34 @@ -95,7 +75,7 @@ 2025-03-05 16:01:34 7 [0,2.1] 0.09999990463256836 2025-03-05 16:01:34 8 [0,2.2] 0.20000004768371582 2025-03-05 16:01:34 - Annoy: WHERE-type, EXPLAIN 2025-03-05 16:01:34 -Expression ((Projection + Before ORDER BY)) 2025-03-05 16:01:34 +Expression ((Project names + Projection)) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Expression 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_annoy) 2025-03-05 16:01:34 @@ -104,29 +84,19 @@ 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 4/4 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: annoy GRANULARITY 2 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/4 2025-03-05 16:01:34 - Annoy: ORDER-BY-type, EXPLAIN 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_annoy) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 4/4 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: annoy GRANULARITY 2 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 2/4 2025-03-05 16:01:34 - Usearch: WHERE-type, EXPLAIN 2025-03-05 16:01:34 -Expression ((Projection + Before ORDER BY)) 2025-03-05 16:01:34 +Expression ((Project names + Projection)) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Expression 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_usearch) 2025-03-05 16:01:34 @@ -135,27 +105,17 @@ 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 4/4 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: usearch GRANULARITY 2 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 1/4 2025-03-05 16:01:34 - Usearch: ORDER-BY-type, EXPLAIN 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_usearch) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 Condition: true 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 4/4 2025-03-05 16:01:34 - Skip 2025-03-05 16:01:34 - Name: idx 2025-03-05 16:01:34 - Description: usearch GRANULARITY 2 2025-03-05 16:01:34 - Parts: 1/1 2025-03-05 16:01:34 - Granules: 2/4 2025-03-05 16:01:34 TUPLE vectors and special cases 2025-03-05 16:01:34 - Annoy: WHERE-type 2025-03-05 16:01:34 0 (4.6,2.3) 0.5527864045000421 2025-03-05 16:01:34 @@ -163,24 +123,27 @@ 2025-03-05 16:01:34 2 (4.2,3.4) 0.37080174340866845 2025-03-05 16:01:34 - Annoy: ORDER-BY-type 2025-03-05 16:01:34 6 (1,9.3) 0.005731362878640178 2025-03-05 16:01:34 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 16:01:34 1 (2,3.2) 0.15200169244542905 2025-03-05 16:01:34 -7 (5.5,4.7) 0.3503476876550442 2025-03-05 16:01:34 - Usearch: WHERE-type 2025-03-05 16:01:34 0 (4.6,2.3) 0.5527864045000421 2025-03-05 16:01:34 1 (2,3.2) 0.15200169244542905 2025-03-05 16:01:34 2 (4.2,3.4) 0.37080174340866845 2025-03-05 16:01:34 - Usearch: ORDER-BY-type 2025-03-05 16:01:34 6 (1,9.3) 0.005731362878640178 2025-03-05 16:01:34 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 16:01:34 1 (2,3.2) 0.15200169244542905 2025-03-05 16:01:34 -7 (5.5,4.7) 0.3503476876550442 2025-03-05 16:01:34 - Special case: MaximumDistance is negative 2025-03-05 16:01:34 - Special case: MaximumDistance is negative 2025-03-05 16:01:34 - Special case: setting "annoy_index_search_k_nodes" 2025-03-05 16:01:34 +6 (1,9.3) 0.005731362878640178 2025-03-05 16:01:34 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 16:01:34 +1 (2,3.2) 0.15200169244542905 2025-03-05 16:01:34 - Special case: setting "max_limit_for_ann_queries" 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_annoy) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 @@ -188,10 +151,10 @@ 2025-03-05 16:01:34 Parts: 1/1 2025-03-05 16:01:34 Granules: 4/4 2025-03-05 16:01:34 - Special case: setting "max_limit_for_ann_queries" 2025-03-05 16:01:34 -Expression (Projection) 2025-03-05 16:01:34 +Expression (Project names) 2025-03-05 16:01:34 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 16:01:34 Sorting (Sorting for ORDER BY) 2025-03-05 16:01:34 - Expression (Before ORDER BY) 2025-03-05 16:01:34 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 16:01:34 ReadFromMergeTree (default.tab_usearch) 2025-03-05 16:01:34 Indexes: 2025-03-05 16:01:34 PrimaryKey 2025-03-05 16:01:34 2025-03-05 16:01:34 2025-03-05 16:01:34 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 47551843 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 10111034 --max_read_buffer_size 524466 --prefer_localhost_replica 0 --max_block_size 74368 --max_threads 52 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 100 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 5024811 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 2996842867 --local_filesystem_read_method read --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 2 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 1 --max_bytes_before_external_group_by 5864445587 --max_bytes_before_remerge_sort 1874197718 --min_compress_block_size 2180536 --max_compress_block_size 3129155 --merge_tree_compact_parts_min_granules_to_multibuffer_read 14 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 7366021 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --prefer_warmed_unmerged_parts_seconds 7 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.95 2025-03-05 16:01:34 2025-03-05 16:01:34 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.7651602721440433 --prefer_fetch_merged_part_size_threshold 6808508434 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 3944061947 --index_granularity_bytes 7816492 --merge_max_block_size 2209 --index_granularity 63582 --min_bytes_for_wide_part 405882860 --marks_compress_block_size 13095 --primary_key_compress_block_size 38153 --replace_long_file_name_to_hash 0 --max_file_name_length 56 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 517855984 --compact_parts_max_granules_to_buffer 252 --compact_parts_merge_max_bytes_to_prefetch_part 1289650 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 94 --old_parts_lifetime 274 2025-03-05 16:01:34 2025-03-05 16:01:34 Database: test_7qgluc0n 2025-03-05 16:01:34 02347_rank_corr_nan: [ OK ] 0.69 sec. 2025-03-05 16:01:35 02346_inverted_index_bug47393: [ OK ] 1.17 sec. 2025-03-05 16:01:35 02346_inverted_index_match_predicate: [ OK ] 1.57 sec. 2025-03-05 16:01:37 02346_inverted_index_bug52019: [ OK ] 1.24 sec. 2025-03-05 16:01:39 02343_group_by_use_nulls: [ OK ] 2.75 sec. 2025-03-05 16:01:40 02344_distinct_limit_distiributed: [ OK ] 4.18 sec. 2025-03-05 16:01:41 02340_analyzer_functions: [ OK ] 1.08 sec. 2025-03-05 16:01:41 02342_window_view_different_struct: [ OK ] 1.94 sec. 2025-03-05 16:01:43 02326_numbers_from_json_strings_schema_inference: [ OK ] 0.96 sec. 2025-03-05 16:01:43 02354_vector_search_bugs: [ OK ] 16.46 sec. 2025-03-05 16:01:43 02337_join_analyze_stuck: [ OK ] 2.36 sec. 2025-03-05 16:01:45 02319_dict_get_check_arguments_size: [ OK ] 1.93 sec. 2025-03-05 16:01:45 02316_values_table_func_bug: [ OK ] 0.62 sec. 2025-03-05 16:01:47 02423_ddl_for_opentelemetry: [ OK ] 46.66 sec. 2025-03-05 16:01:47 02312_parquet_orc_arrow_names_tuples: [ OK ] 1.95 sec. 2025-03-05 16:01:47 02316_hierarchical_dictionaries_nullable_parent_key: [ OK ] 4.10 sec. 2025-03-05 16:01:48 02311_range_hashed_dictionary_range_cast: [ OK ] 1.08 sec. 2025-03-05 16:01:49 02304_grouping_set_order_by: [ OK ] 0.70 sec. 2025-03-05 16:01:49 02311_create_table_with_unknown_format: [ OK ] 1.89 sec. 2025-03-05 16:01:50 02311_system_zookeeper_insert: [ OK ] 2.95 sec. 2025-03-05 16:01:50 02296_nullable_arguments_in_array_filter: [ OK ] 0.79 sec. 2025-03-05 16:01:51 02302_projections_GROUP_BY_ORDERY_BY_optimize_aggregation_in_order: [ OK ] 1.36 sec. 2025-03-05 16:01:51 02294_system_certificates: [ OK ] 0.68 sec. 2025-03-05 16:01:52 02294_optimize_aggregation_in_order_prefix_Array_functions: [ OK ] 1.06 sec. 2025-03-05 16:01:52 02295_GROUP_BY_AggregateFunction: [ OK ] 1.95 sec. 2025-03-05 16:01:52 02389_analyzer_nested_lambda: [ OK ] 46.86 sec. 2025-03-05 16:01:54 02286_tuple_numeric_identifier: [ OK ] 1.65 sec. 2025-03-05 16:01:54 02293_http_header_full_summary_without_progress: [ OK ] 3.51 sec. 2025-03-05 16:01:54 02275_full_sort_join_long: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 16:01:55 02293_http_header_summary_contains_exception_code_with_progress: [ OK ] 3.04 sec. 2025-03-05 16:01:55 02280_add_query_level_settings: [ OK ] 1.09 sec. 2025-03-05 16:01:55 02293_grouping_function_group_by: [ OK ] 3.48 sec. 2025-03-05 16:01:56 02271_temporary_table_show_rows_bytes: [ OK ] 0.68 sec. 2025-03-05 16:01:56 02269_to_start_of_interval_overflow: [ OK ] 0.86 sec. 2025-03-05 16:01:57 02267_insert_empty_data: [ OK ] 0.77 sec. 2025-03-05 16:01:59 02267_empty_arrays_read_reverse: [ OK ] 3.08 sec. 2025-03-05 16:02:01 02428_parameterized_view: [ OK ] 63.69 sec. 2025-03-05 16:02:02 02267_join_dup_columns_issue36199: [ OK ] 3.03 sec. 2025-03-05 16:02:02 02267_type_inference_for_insert_into_function_null: [ OK ] 0.97 sec. 2025-03-05 16:02:04 02267_file_globs_schema_inference: [ OK ] 6.79 sec. 2025-03-05 16:02:05 02473_multistep_split_prewhere: [ OK ] 71.94 sec. 2025-03-05 16:02:05 02267_special_operator_parse_alias_check: [ OK ] 2.84 sec. 2025-03-05 16:02:07 02270_errors_in_files: [ OK ] 11.51 sec. 2025-03-05 16:02:07 02265_column_ttl: [ OK ] 4.65 sec. 2025-03-05 16:02:08 02246_clickhouse_local_drop_database: [ OK ] 3.12 sec. 2025-03-05 16:02:08 02245_s3_virtual_columns: [ OK ] 1.22 sec. 2025-03-05 16:02:09 02245_s3_schema_desc: [ OK ] 1.26 sec. 2025-03-05 16:02:10 02250_ON_CLUSTER_grant: [ OK ] 5.08 sec. 2025-03-05 16:02:11 02242_if_then_else_null_bug: [ OK ] 0.88 sec. 2025-03-05 16:02:11 02245_make_datetime64: [ OK ] 4.49 sec. 2025-03-05 16:02:11 02242_make_date_mysql: [ OK ] 1.95 sec. 2025-03-05 16:02:12 02241_short_circuit_short_column: [ OK ] 0.72 sec. 2025-03-05 16:02:12 02243_make_date32: [ OK ] 3.69 sec. 2025-03-05 16:02:12 02240_asof_join_biginteger: [ OK ] 0.90 sec. 2025-03-05 16:02:13 02236_json_each_row_empty_map_schema_inference: [ OK ] 0.66 sec. 2025-03-05 16:02:13 02233_with_total_empty_chunk: [ OK ] 0.69 sec. 2025-03-05 16:02:14 02232_partition_pruner_mixed_constant_type: [ OK ] 0.87 sec. 2025-03-05 16:02:15 02231_hierarchical_dictionaries_constant: [ OK ] 2.08 sec. 2025-03-05 16:02:16 02254_projection_broken_part: [ OK ] 11.79 sec. 2025-03-05 16:02:17 02212_h3_get_pentagon_indexes: [ OK ] 1.46 sec. 2025-03-05 16:02:19 02241_parquet_bad_column: [ OK ] 7.48 sec. 2025-03-05 16:02:19 02317_distinct_in_order_optimization_explain: [ OK ] 35.78 sec. 2025-03-05 16:02:20 02237_lzma_bug: [ OK ] 8.03 sec. 2025-03-05 16:02:20 02192_comment: [ OK ] 0.75 sec. 2025-03-05 16:02:22 02186_range_hashed_dictionary_intersecting_intervals: [ OK ] 1.77 sec. 2025-03-05 16:02:22 02210_processors_profile_log: [ OK ] 5.02 sec. 2025-03-05 16:02:23 02229_client_stop_multiquery_in_SIGINT: [ OK ] 8.67 sec. 2025-03-05 16:02:23 02192_comment_error: [ OK ] 3.54 sec. 2025-03-05 16:02:23 02205_map_populate_series_non_const: [ OK ] 3.80 sec. 2025-03-05 16:02:23 02181_sql_user_defined_functions_invalid_lambda: [ OK ] 0.68 sec. 2025-03-05 16:02:24 02481_async_insert_dedup_token: [ OK ] 95.92 sec. 2025-03-05 16:02:24 02180_group_by_lowcardinality: [ OK ] 1.56 sec. 2025-03-05 16:02:24 02177_merge_optimize_aggregation_in_order: [ OK ] 1.52 sec. 2025-03-05 16:02:24 02179_range_hashed_dictionary_invalid_interval: [ OK ] 1.59 sec. 2025-03-05 16:02:24 02176_toStartOfWeek_overflow_pruning: [ OK ] 1.19 sec. 2025-03-05 16:02:26 02160_h3_cell_area_m2: [ OK ] 1.20 sec. 2025-03-05 16:02:26 02162_array_first_last_index: [ OK ] 1.42 sec. 2025-03-05 16:02:27 02155_nested_lc_defalut_bug: [ OK ] 1.08 sec. 2025-03-05 16:02:27 02183_combinator_if: [ OK ] 4.63 sec. 2025-03-05 16:02:27 02176_dict_get_has_implicit_key_cast: [ OK ] 3.12 sec. 2025-03-05 16:02:28 02158_proportions_ztest_cmp: [ OK ] 3.14 sec. 2025-03-05 16:02:28 02150_replace_regexp_all_empty_match: [ OK ] 0.71 sec. 2025-03-05 16:02:28 02152_dictionary_date32_type: [ OK ] 1.23 sec. 2025-03-05 16:02:29 02146_mv_non_phys: [ OK ] 0.75 sec. 2025-03-05 16:02:29 02174_cte_scalar_cache: [ OK ] 4.77 sec. 2025-03-05 16:02:30 02136_scalar_progress: [ OK ] 1.68 sec. 2025-03-05 16:02:31 02141_clickhouse_local_interactive_table: [ OK ] 2.65 sec. 2025-03-05 16:02:31 02221_parallel_replicas_bug: [ OK ] 15.70 sec. 2025-03-05 16:02:32 02133_distributed_queries_formatting: [ OK ] 0.81 sec. 2025-03-05 16:02:32 02135_local_create_db: [ OK ] 2.93 sec. 2025-03-05 16:02:33 02154_bit_slice_for_fixedstring: [ OK ] 7.31 sec. 2025-03-05 16:02:37 02131_used_row_policies_in_query_log: [ OK ] 6.27 sec. 2025-03-05 16:02:38 02149_schema_inference_formats_with_schema_3: [ OK ] 10.00 sec. 2025-03-05 16:02:38 02126_fix_filelog: [ OK ] 6.00 sec. 2025-03-05 16:02:39 02125_dict_get_type_nullable_fix: [ OK ] 1.28 sec. 2025-03-05 16:02:39 02124_encrypt_decrypt_nullable: [ OK ] 1.58 sec. 2025-03-05 16:02:41 02134_async_inserts_formats: [ OK ] 10.13 sec. 2025-03-05 16:02:41 02124_insert_deduplication_token_replica: [ OK ] 3.04 sec. 2025-03-05 16:02:49 02122_parallel_formatting_Values: [ OK ] 7.92 sec. 2025-03-05 16:02:49 02125_lz4_compression_bug_TSKV: [ OK ] 16.13 sec. 2025-03-05 16:02:50 02122_parallel_formatting_JSONEachRow: [ OK ] 8.92 sec. 2025-03-05 16:02:50 02274_full_sort_join_nodistinct: [ OK ] 55.87 sec. 2025-03-05 16:02:50 02113_untuple_func_alias: [ OK ] 0.85 sec. 2025-03-05 16:02:52 02122_parallel_formatting_TSVWithNames: [ OK ] 12.17 sec. 2025-03-05 16:02:52 02125_lz4_compression_bug_JSONCompactEachRow: [ OK ] 19.57 sec. 2025-03-05 16:02:52 02122_parallel_formatting_Pretty: [ OK ] 13.25 sec. 2025-03-05 16:02:52 02111_global_context_temporary_tables: [ OK ] 1.81 sec. 2025-03-05 16:02:53 02096_totals_global_in_bug: [ OK ] 1.26 sec. 2025-03-05 16:02:54 02053_INSERT_SELECT_MATERIALIZED: [ OK ] 1.59 sec. 2025-03-05 16:02:54 02119_sumcount: [ OK ] 4.76 sec. 2025-03-05 16:02:54 02096_date_time_1970_saturation: [ OK ] 2.05 sec. 2025-03-05 16:02:55 02097_remove_sample_by: [ OK ] 2.93 sec. 2025-03-05 16:02:56 02050_clickhouse_local_parsing_exception: [ OK ] 2.16 sec. 2025-03-05 16:02:56 02122_parallel_formatting_JSONCompactEachRow: [ OK ] 6.89 sec. 2025-03-05 16:02:56 02045_like_function: [ OK ] 0.77 sec. 2025-03-05 16:02:57 02049_clickhouse_local_merge_tree: [ OK ] 2.51 sec. 2025-03-05 16:02:57 02042_map_get_non_const_key: [ OK ] 1.00 sec. 2025-03-05 16:02:57 02032_short_circuit_least_greatest_bug: [ OK ] 0.90 sec. 2025-03-05 16:02:58 02029_quantile_sanitizer: [ OK ] 0.84 sec. 2025-03-05 16:02:58 02031_format_query_option: [ OK ] 1.76 sec. 2025-03-05 16:02:58 02024_create_dictionary_with_comment: [ OK ] 1.10 sec. 2025-03-05 16:02:59 02025_subcolumns_compact_parts: [ OK ] 1.89 sec. 2025-03-05 16:02:59 02019_multiple_weird_with_fill: [ OK ] 0.76 sec. 2025-03-05 16:03:01 02017_columns_with_dot: [ OK ] 2.28 sec. 2025-03-05 16:03:01 02013_emptystring_cast: [ OK ] 1.98 sec. 2025-03-05 16:03:02 02021_map_bloom_filter_index: [ OK ] 4.16 sec. 2025-03-05 16:03:04 02010_array_index_bad_cast: [ OK ] 1.11 sec. 2025-03-05 16:03:04 02013_bloom_filter_hasAll: [ OK ] 3.03 sec. 2025-03-05 16:03:05 02009_array_join_partition: [ OK ] 1.29 sec. 2025-03-05 16:03:06 02006_use_constants_in_with_and_select: [ OK ] 1.42 sec. 2025-03-05 16:03:11 02047_log_family_complex_structs_data_file_dumps: [ OK ] 16.80 sec. 2025-03-05 16:03:11 02047_log_family_data_file_sizes: [ OK ] 17.06 sec. 2025-03-05 16:03:11 01956_skip_unavailable_shards_excessive_attempts: [ OK ] 5.12 sec. 2025-03-05 16:03:12 01948_group_bitmap_and_or_xor_fix: [ OK ] 1.01 sec. 2025-03-05 16:03:14 02011_tuple_vector_functions: [ OK ] 12.07 sec. 2025-03-05 16:03:14 02023_storage_filelog: [ OK ] 15.59 sec. 2025-03-05 16:03:14 01949_heredoc_unfinished: [ OK ] 2.57 sec. 2025-03-05 16:03:15 01940_custom_tld_sharding_key: [ OK ] 1.37 sec. 2025-03-05 16:03:16 02004_max_hyperscan_regex_length: [ OK ] 10.60 sec. 2025-03-05 16:03:16 02150_index_hypothesis_race_long: [ OK ] 48.62 sec. 2025-03-05 16:03:16 01925_date_date_time_comparison: [ OK ] 0.91 sec. 2025-03-05 16:03:17 01925_jit_aggregation_function_count_long: [ OK ] 1.11 sec. 2025-03-05 16:03:17 01925_merge_prewhere_table: [ OK ] 1.22 sec. 2025-03-05 16:03:18 01913_fix_column_transformer_replace_format: [ OK ] 1.00 sec. 2025-03-05 16:03:18 01923_ttl_with_modify_column: [ OK ] 2.06 sec. 2025-03-05 16:03:19 01891_partition_by_uuid: [ OK ] 1.04 sec. 2025-03-05 16:03:19 01892_setting_limit_offset_distributed: [ OK ] 1.99 sec. 2025-03-05 16:03:20 01927_query_views_log_current_database: [ OK ] 6.31 sec. 2025-03-05 16:03:21 01939_network_receive_bytes_metrics: [ OK ] 6.79 sec. 2025-03-05 16:03:21 01881_create_as_tuple: [ OK ] 1.38 sec. 2025-03-05 16:03:21 01868_order_by_fill_with_datetime64: [ OK ] 0.89 sec. 2025-03-05 16:03:23 01889_clickhouse_client_config_format: [ OK ] 4.43 sec. 2025-03-05 16:03:23 01865_aggregator_overflow_row: [ OK ] 1.78 sec. 2025-03-05 16:03:24 01853_s2_cells_intersect: [ OK ] 1.23 sec. 2025-03-05 16:03:24 01852_s2_get_neighbours: [ OK ] 0.73 sec. 2025-03-05 16:03:25 01851_hedged_connections_external_tables: [ OK ] 1.12 sec. 2025-03-05 16:03:27 01866_view_persist_settings: [ OK ] 5.68 sec. 2025-03-05 16:03:28 01846_alter_column_without_type_bugfix: [ OK ] 1.02 sec. 2025-03-05 16:03:29 01848_partition_value_column: [ OK ] 3.29 sec. 2025-03-05 16:03:29 01849_geoToS2: [ OK ] 4.64 sec. 2025-03-05 16:03:29 01838_system_dictionaries_virtual_key_column: [ OK ] 1.31 sec. 2025-03-05 16:03:29 01871_merge_tree_compile_expressions: [ OK ] 8.74 sec. 2025-03-05 16:03:30 01835_alias_to_primary_key_cyfdecyf: [ OK ] 1.32 sec. 2025-03-05 16:03:31 01825_type_json_5: [ OK ] 1.65 sec. 2025-03-05 16:03:32 01946_profile_sleep: [ OK ] 19.58 sec. 2025-03-05 16:03:35 01825_type_json_7: [ OK ] 5.62 sec. 2025-03-05 16:03:35 01881_join_on_conditions_merge: [ OK ] 15.92 sec. 2025-03-05 16:03:36 01825_type_json_18: [ OK ] 1.09 sec. 2025-03-05 16:03:37 01825_type_json_16: [ OK ] 6.55 sec. 2025-03-05 16:03:37 01825_type_json_partitions: [ OK ] 1.25 sec. 2025-03-05 16:03:38 01822_union_and_constans_error: [ OK ] 1.39 sec. 2025-03-05 16:03:38 01825_type_json_schema_inference: [ OK ] 9.49 sec. 2025-03-05 16:03:39 01804_uniq_up_to_ubsan: [ OK ] 1.01 sec. 2025-03-05 16:03:40 01825_type_json_8: [ OK ] 7.70 sec. 2025-03-05 16:03:40 01802_formatDateTime_DateTime64_century: [ OK ] 1.46 sec. 2025-03-05 16:03:41 01802_rank_corr_mann_whitney_over_window: [ OK ] 1.26 sec. 2025-03-05 16:03:41 01798_having_push_down: [ OK ] 1.32 sec. 2025-03-05 16:03:42 01796_Log_rwlock_ub: [ OK ] 0.93 sec. 2025-03-05 16:03:42 01811_storage_buffer_flush_parameters: [ OK ] 4.13 sec. 2025-03-05 16:03:43 01787_arena_assert_column_nothing: [ OK ] 0.84 sec. 2025-03-05 16:03:43 01790_dist_INSERT_block_structure_mismatch_types_and_names: [ OK ] 1.60 sec. 2025-03-05 16:03:44 01785_pmj_lc_bug: [ OK ] 1.88 sec. 2025-03-05 16:03:45 01825_type_json_in_other_types: [ OK ] 9.35 sec. 2025-03-05 16:03:46 01784_parallel_formatting_memory: [ OK ] 3.14 sec. 2025-03-05 16:03:51 01780_column_sparse_pk: [ OK ] 4.07 sec. 2025-03-05 16:03:51 01954_clickhouse_benchmark_multiple_long: [ OK ] 39.50 sec. 2025-03-05 16:03:52 01774_bar_with_illegal_value: [ OK ] 0.79 sec. 2025-03-05 16:03:52 01785_parallel_formatting_memory: [ OK ] 9.43 sec. 2025-03-05 16:03:52 01781_token_extractor_buffer_overflow: [ OK ] 8.53 sec. 2025-03-05 16:03:52 01780_column_sparse_filter: [ OK ] 1.68 sec. 2025-03-05 16:03:53 01773_min_max_time_system_parts_datetime64: [ OK ] 1.01 sec. 2025-03-05 16:03:53 01770_extended_range_3: [ OK ] 0.98 sec. 2025-03-05 16:03:53 01768_extended_range: [ OK ] 0.88 sec. 2025-03-05 16:03:53 01769_extended_range_2: [ OK ] 0.92 sec. 2025-03-05 16:03:54 01766_todatetime64_no_timezone_arg: [ OK ] 0.71 sec. 2025-03-05 16:03:55 01781_merge_tree_deduplication: [ OK ] 10.57 sec. 2025-03-05 16:03:55 01767_timezoneOf: [ OK ] 2.48 sec. 2025-03-05 16:03:55 01748_partition_id_pruning: [ OK ] 2.03 sec. 2025-03-05 16:03:57 01736_null_as_default: [ OK ] 1.06 sec. 2025-03-05 16:03:57 01746_long_zlib_http_compression_json_format: [ OK ] 2.50 sec. 2025-03-05 16:03:57 01799_long_uniq_theta_sketch: [ OK ] 17.15 sec. 2025-03-05 16:03:57 01746_test_for_tupleElement_must_be_constant_issue: [ OK ] 1.84 sec. 2025-03-05 16:03:57 01732_union_and_union_all: [ OK ] 0.68 sec. 2025-03-05 16:03:58 01720_union_distinct_with_limit: [ OK ] 0.70 sec. 2025-03-05 16:03:58 01739_index_hint: [ OK ] 2.79 sec. 2025-03-05 16:03:59 01716_drop_rename_sign_column: [ OK ] 1.16 sec. 2025-03-05 16:03:59 01715_table_function_view_fix: [ OK ] 0.85 sec. 2025-03-05 16:04:00 01714_alter_drop_version: [ OK ] 1.28 sec. 2025-03-05 16:04:00 01710_projection_with_column_transformers: [ OK ] 0.83 sec. 2025-03-05 16:04:00 01710_projection_with_mixed_pipeline: [ OK ] 1.22 sec. 2025-03-05 16:04:01 01710_minmax_count_projection_constant_query: [ OK ] 1.02 sec. 2025-03-05 16:04:01 01710_force_use_projection: [ OK ] 1.59 sec. 2025-03-05 16:04:02 01763_long_ttl_group_by: [ OK ] 8.68 sec. 2025-03-05 16:04:02 01710_minmax_count_projection_distributed_query: [ OK ] 1.14 sec. 2025-03-05 16:04:03 01710_minmax_count_projection_modify_partition_key: [ OK ] 1.25 sec. 2025-03-05 16:04:03 01710_normal_projection_format: [ OK ] 1.05 sec. 2025-03-05 16:04:05 01701_clear_projection_and_part_remove: [ OK ] 2.09 sec. 2025-03-05 16:04:06 01710_query_log_with_projection_info: [ OK ] 5.76 sec. 2025-03-05 16:04:07 01691_DateTime64_clamp: [ OK ] 1.21 sec. 2025-03-05 16:04:07 02099_tsv_raw_format: [ OK ] 76.18 sec. 2025-03-05 16:04:07 01825_type_json_ghdata_insert_select: [ OK ] 36.59 sec. 2025-03-05 16:04:08 01683_intdiv_ubsan: [ OK ] 1.07 sec. 2025-03-05 16:04:08 01683_dist_INSERT_block_structure_mismatch: [ OK ] 1.32 sec. 2025-03-05 16:04:08 01686_rocksdb: [ OK ] 2.59 sec. 2025-03-05 16:04:08 01682_gather_utils_ubsan: [ OK ] 0.90 sec. 2025-03-05 16:04:09 01674_unicode_asan: [ OK ] 1.01 sec. 2025-03-05 16:04:09 01673_test_toMinute_mysql_dialect: [ OK ] 0.68 sec. 2025-03-05 16:04:09 01670_test_repeat_mysql_dialect: [ OK ] 0.59 sec. 2025-03-05 16:04:09 01720_country_perimeter_and_area: [ OK ] 12.08 sec. 2025-03-05 16:04:10 01666_date_lut_buffer_overflow: [ OK ] 0.72 sec. 2025-03-05 16:04:10 01668_avg_weighted_ubsan: [ OK ] 0.78 sec. 2025-03-05 16:04:10 01681_bloom_filter_nullable_column: [ OK ] 2.23 sec. 2025-03-05 16:04:11 01665_substring_ubsan: [ OK ] 0.72 sec. 2025-03-05 16:04:12 01666_gcd_ubsan: [ OK ] 2.96 sec. 2025-03-05 16:04:12 01666_lcm_ubsan: [ OK ] 2.82 sec. 2025-03-05 16:04:13 01660_join_or_inner: [ OK ] 2.06 sec. 2025-03-05 16:04:13 01659_test_base64Decode_mysql_compatibility: [ OK ] 0.68 sec. 2025-03-05 16:04:13 01655_agg_if_nullable: [ OK ] 0.90 sec. 2025-03-05 16:04:14 01655_window_functions_bug: [ OK ] 0.73 sec. 2025-03-05 16:04:14 01655_sleep_infinite_float: [ OK ] 0.93 sec. 2025-03-05 16:04:14 01662_date_ubsan: [ OK ] 3.82 sec. 2025-03-05 16:04:14 01632_nullable_string_type_convert_to_decimal_type: [ OK ] 0.63 sec. 2025-03-05 16:04:15 01646_fix_window_funnel_inconistency: [ OK ] 1.20 sec. 2025-03-05 16:04:15 01660_join_or_all: [ OK ] 4.74 sec. 2025-03-05 16:04:16 01616_untuple_access_field: [ OK ] 0.66 sec. 2025-03-05 16:04:16 01626_cnf_test: [ OK ] 1.15 sec. 2025-03-05 16:04:16 01615_two_args_function_index_fix: [ OK ] 1.07 sec. 2025-03-05 16:04:18 01603_remove_column_ttl: [ OK ] 1.78 sec. 2025-03-05 16:04:18 01648_mutations_and_escaping: [ OK ] 4.98 sec. 2025-03-05 16:04:19 01603_decimal_mult_float: [ OK ] 2.84 sec. 2025-03-05 16:04:20 01601_proxy_protocol: [ OK ] 1.99 sec. 2025-03-05 16:04:20 01600_min_max_compress_block_size: [ OK ] 1.20 sec. 2025-03-05 16:04:21 01592_toUnixTimestamp_Date: [ OK ] 0.82 sec. 2025-03-05 16:04:23 01585_use_index_for_global_in: [ OK ] 2.14 sec. 2025-03-05 16:04:24 01600_quota_by_forwarded_ip: [ OK ] 5.33 sec. 2025-03-05 16:04:25 01580_column_const_comparision: [ OK ] 0.89 sec. 2025-03-05 16:04:27 01632_tinylog_read_write: [ OK ] 12.84 sec. 2025-03-05 16:04:27 01710_projections_optimize_aggregation_in_order: [ OK ] 23.94 sec. 2025-03-05 16:04:27 01710_projections_partial_optimize_aggregation_in_order: [ OK ] 24.78 sec. 2025-03-05 16:04:28 01561_aggregate_functions_of_key_with_join: [ OK ] 1.00 sec. 2025-03-05 16:04:29 01562_optimize_monotonous_functions_in_order_by: [ OK ] 2.27 sec. 2025-03-05 16:04:30 01558_enum_as_num_in_tsv_csv_input: [ OK ] 1.44 sec. 2025-03-05 16:04:54 01551_mergetree_read_in_order_spread: [ FAIL ] 24.48 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 17660942 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 15770436 --max_read_buffer_size 841836 --prefer_localhost_replica 0 --max_block_size 44421 --max_threads 48 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 68 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 1338292 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 19 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 3388511306 --max_bytes_before_external_group_by 1 --max_bytes_before_remerge_sort 1505304031 --min_compress_block_size 1882354 --max_compress_block_size 503016 --merge_tree_compact_parts_min_granules_to_multibuffer_read 100 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4925996 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --prefer_warmed_unmerged_parts_seconds 0 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.59 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_e4e4k6ef 2025-03-05 16:04:54 01576_if_null_external_aggregation: [ FAIL ] 29.59 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 352685 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 14727427 --max_read_buffer_size 732603 --prefer_localhost_replica 0 --max_block_size 78537 --max_threads 35 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 76 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 25309117 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 1 --max_bytes_before_remerge_sort 2900155073 --min_compress_block_size 1451796 --max_compress_block_size 1133005 --merge_tree_compact_parts_min_granules_to_multibuffer_read 68 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5376052 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --prefer_warmed_unmerged_parts_seconds 8 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.8 2025-03-05 16:04:54 2025-03-05 16:04:54 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 7444232723 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 650624196 --index_granularity_bytes 15453726 --merge_max_block_size 13559 --index_granularity 42205 --min_bytes_for_wide_part 993923584 --marks_compress_block_size 96418 --primary_key_compress_block_size 93158 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 32130801 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 27973444 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 474 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_u0zo3l7e 2025-03-05 16:04:54 01603_read_with_backoff_bug: [ FAIL ] 38.66 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 4 --group_by_two_level_threshold 888375 --group_by_two_level_threshold_bytes 6423610 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 9938406 --max_read_buffer_size 548187 --prefer_localhost_replica 0 --max_block_size 56011 --max_threads 13 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 42 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 23410397 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 13 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1133293431 --min_compress_block_size 774023 --max_compress_block_size 2772716 --merge_tree_compact_parts_min_granules_to_multibuffer_read 26 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 7811163 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 6 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.39 2025-03-05 16:04:54 2025-03-05 16:04:54 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 6211324403 --index_granularity_bytes 26066224 --merge_max_block_size 9980 --index_granularity 25099 --min_bytes_for_wide_part 167699161 --marks_compress_block_size 60702 --primary_key_compress_block_size 72136 --replace_long_file_name_to_hash 1 --max_file_name_length 115 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 516603583 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 2847024 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 10 --old_parts_lifetime 480 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_4cez227c 2025-03-05 16:04:54 01581_deduplicate_by_columns_local: [ FAIL ] 31.49 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 371010 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 8161790 --max_read_buffer_size 531977 --prefer_localhost_replica 0 --max_block_size 43419 --max_threads 23 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 52 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 13671530 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 8892838063 --min_bytes_to_use_mmap_io 5498833930 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 13 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 2967993850 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 603780650 --min_compress_block_size 1793208 --max_compress_block_size 1689203 --merge_tree_compact_parts_min_granules_to_multibuffer_read 61 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 2412854 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 5 --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.94 2025-03-05 16:04:54 2025-03-05 16:04:54 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.28683858574310483 --prefer_fetch_merged_part_size_threshold 10280414649 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 5024969178 --index_granularity_bytes 14309964 --merge_max_block_size 14349 --index_granularity 9721 --min_bytes_for_wide_part 0 --marks_compress_block_size 87219 --primary_key_compress_block_size 22151 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 470949232 --compact_parts_max_granules_to_buffer 214 --compact_parts_merge_max_bytes_to_prefetch_part 23691029 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 86 --old_parts_lifetime 30 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_s02ro35b 2025-03-05 16:04:54 01721_join_implicit_cast_long: [ FAIL ] 57.73 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 11 --group_by_two_level_threshold 318770 --group_by_two_level_threshold_bytes 20004747 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 4854568 --max_read_buffer_size 617400 --prefer_localhost_replica 1 --max_block_size 40768 --max_threads 55 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 61 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 40089044 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 3 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 1 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1404774062 --min_compress_block_size 1209006 --max_compress_block_size 2619940 --merge_tree_compact_parts_min_granules_to_multibuffer_read 20 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 3481388 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone America/Grenada --prefer_warmed_unmerged_parts_seconds 4 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.15 2025-03-05 16:04:54 2025-03-05 16:04:54 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 25350550 --merge_max_block_size 2398 --index_granularity 56936 --min_bytes_for_wide_part 625970783 --marks_compress_block_size 95658 --primary_key_compress_block_size 61680 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 420494668 --compact_parts_max_bytes_to_buffer 15682513 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 2810028 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 77 --old_parts_lifetime 471 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_iddy6d2o 2025-03-05 16:04:54 01558_transform_null_in: [ FAIL ] 25.08 sec. - server died 2025-03-05 16:04:54 ConnectionRefusedError 2025-03-05 16:04:54 [Errno 111] Connection refused 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 311, in clickhouse_execute_http 2025-03-05 16:04:54 raise ex 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 2025-03-05 16:04:54 Settings used in the test: --max_insert_threads 16 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 15084632 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 16334555 --max_read_buffer_size 582976 --prefer_localhost_replica 1 --max_block_size 71417 --max_threads 11 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 51 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 38295408 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 7432698871 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 10 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1094589366 --min_compress_block_size 2969222 --max_compress_block_size 2316909 --merge_tree_compact_parts_min_granules_to_multibuffer_read 61 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 10352519 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Grenada --prefer_warmed_unmerged_parts_seconds 2 --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.07 2025-03-05 16:04:54 2025-03-05 16:04:54 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 89 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 4410729485 --index_granularity_bytes 30258289 --merge_max_block_size 1889 --index_granularity 60077 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 78553 --primary_key_compress_block_size 21089 --replace_long_file_name_to_hash 0 --max_file_name_length 111 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 339156642 --compact_parts_max_granules_to_buffer 156 --compact_parts_merge_max_bytes_to_prefetch_part 4067468 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 419 2025-03-05 16:04:54 2025-03-05 16:04:54 Database: test_1z3rqoox 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 2025-03-05 16:04:54 Having 1 errors! 50 tests passed. 0 tests skipped. 350.35 s elapsed (ForkPoolWorker-7). 2025-03-05 16:04:54 Process ForkPoolWorker-4: 2025-03-05 16:04:54 Process ForkPoolWorker-3: 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 3392, in 2025-03-05 16:04:54 main(args) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2786, in main 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2172, in run_tests_array 2025-03-05 16:04:54 stop_tests() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 374, in stop_tests 2025-03-05 16:04:54 with stop_tests_triggered_lock: 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/synchronize.py", line 95, in __enter__ 2025-03-05 16:04:54 return self._semlock.__enter__() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 total_tests_run += do_run_tests(args.jobs, test_suite, args.parallel) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2408, in do_run_tests 2025-03-05 16:04:54 Process ForkPoolWorker-9: 2025-03-05 16:04:54 queue.put(suit, timeout=args.timeout * 1.1) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/queues.py", line 89, in put 2025-03-05 16:04:54 Process ForkPoolWorker-8: 2025-03-05 16:04:54 if not self._sem.acquire(block, timeout): 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 __main__.Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2172, in run_tests_array 2025-03-05 16:04:54 stop_tests() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 374, in stop_tests 2025-03-05 16:04:54 with stop_tests_triggered_lock: 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/synchronize.py", line 95, in __enter__ 2025-03-05 16:04:54 return self._semlock.__enter__() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2172, in run_tests_array 2025-03-05 16:04:54 stop_tests() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 374, in stop_tests 2025-03-05 16:04:54 with stop_tests_triggered_lock: 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/synchronize.py", line 95, in __enter__ 2025-03-05 16:04:54 return self._semlock.__enter__() 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 300, in clickhouse_execute_http 2025-03-05 16:04:54 client.request( 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-03-05 16:04:54 self._send_request(method, url, body, headers, encode_chunked) 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-03-05 16:04:54 self.endheaders(body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-03-05 16:04:54 self._send_output(message_body, encode_chunked=encode_chunked) 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-03-05 16:04:54 self.send(msg) 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 976, in send 2025-03-05 16:04:54 self.connect() 2025-03-05 16:04:54 File "/usr/lib/python3.10/http/client.py", line 942, in connect 2025-03-05 16:04:54 self.sock = self._create_connection( 2025-03-05 16:04:54 File "/usr/lib/python3.10/socket.py", line 845, in create_connection 2025-03-05 16:04:54 raise err 2025-03-05 16:04:54 File "/usr/lib/python3.10/socket.py", line 833, in create_connection 2025-03-05 16:04:54 sock.connect(sa) 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 ConnectionRefusedError: [Errno 111] Connection refused 2025-03-05 16:04:54 2025-03-05 16:04:54 During handling of the above exception, another exception occurred: 2025-03-05 16:04:54 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2147, in run_tests_array 2025-03-05 16:04:54 test_result = test_case.run( 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1695, in run 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1691, in run 2025-03-05 16:04:54 self._cleanup(result.status == TestStatus.OK) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1754, in _cleanup 2025-03-05 16:04:54 self._cleanup_database(args, timeout) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1788, in _cleanup_database 2025-03-05 16:04:54 clickhouse_execute( 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 330, in clickhouse_execute 2025-03-05 16:04:54 return clickhouse_execute_http( 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 313, in clickhouse_execute_http 2025-03-05 16:04:54 sleep(i + 1) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 Process ForkPoolWorker-2: 2025-03-05 16:04:54 Process ForkPoolWorker-5: 2025-03-05 16:04:54 Process ForkPoolWorker-6: 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2172, in run_tests_array 2025-03-05 16:04:54 stop_tests() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 374, in stop_tests 2025-03-05 16:04:54 with stop_tests_triggered_lock: 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/synchronize.py", line 95, in __enter__ 2025-03-05 16:04:54 return self._semlock.__enter__() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 2025-03-05 16:04:54 During handling of the above exception, another exception occurred: 2025-03-05 16:04:54 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2172, in run_tests_array 2025-03-05 16:04:54 stop_tests() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 374, in stop_tests 2025-03-05 16:04:54 with stop_tests_triggered_lock: 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/synchronize.py", line 95, in __enter__ 2025-03-05 16:04:54 return self._semlock.__enter__() 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 317, in _bootstrap 2025-03-05 16:04:54 util._exit_function() 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 334, in _exit_function 2025-03-05 16:04:54 _run_finalizers(0) 2025-03-05 16:04:54 2025-03-05 16:04:54 During handling of the above exception, another exception occurred: 2025-03-05 16:04:54 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 300, in _run_finalizers 2025-03-05 16:04:54 finalizer() 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 224, in __call__ 2025-03-05 16:04:54 res = self._callback(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/managers.py", line 870, in _decref 2025-03-05 16:04:54 conn = _Client(token.address, authkey=authkey) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 508, in Client 2025-03-05 16:04:54 answer_challenge(c, authkey) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 757, in answer_challenge 2025-03-05 16:04:54 response = connection.recv_bytes(256) # reject large message 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 216, in recv_bytes 2025-03-05 16:04:54 buf = self._recv_bytes(maxlength) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 414, in _recv_bytes 2025-03-05 16:04:54 buf = self._recv(4) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 379, in _recv 2025-03-05 16:04:54 chunk = read(handle, remaining) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 317, in _bootstrap 2025-03-05 16:04:54 util._exit_function() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 334, in _exit_function 2025-03-05 16:04:54 _run_finalizers(0) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 300, in _run_finalizers 2025-03-05 16:04:54 finalizer() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 224, in __call__ 2025-03-05 16:04:54 res = self._callback(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/managers.py", line 871, in _decref 2025-03-05 16:04:54 dispatch(conn, None, 'decref', (token.id,)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/managers.py", line 90, in dispatch 2025-03-05 16:04:54 kind, result = c.recv() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 250, in recv 2025-03-05 16:04:54 buf = self._recv_bytes() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 414, in _recv_bytes 2025-03-05 16:04:54 buf = self._recv(4) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 379, in _recv 2025-03-05 16:04:54 chunk = read(handle, remaining) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-03-05 16:04:54 self.run() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-03-05 16:04:54 self._target(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 125, in worker 2025-03-05 16:04:54 result = (True, func(*args, **kwds)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/pool.py", line 48, in mapstar 2025-03-05 16:04:54 return list(map(*args)) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2179, in run_tests_array 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 2147, in run_tests_array 2025-03-05 16:04:54 test_result = test_case.run( 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1695, in run 2025-03-05 16:04:54 raise e 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1678, in run 2025-03-05 16:04:54 ) = self.run_single_test(server_logs_level, client_options) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 1585, in run_single_test 2025-03-05 16:04:54 sleep(0.01) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 2025-03-05 16:04:54 During handling of the above exception, another exception occurred: 2025-03-05 16:04:54 2025-03-05 16:04:54 Traceback (most recent call last): 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/process.py", line 317, in _bootstrap 2025-03-05 16:04:54 util._exit_function() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 334, in _exit_function 2025-03-05 16:04:54 _run_finalizers(0) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 300, in _run_finalizers 2025-03-05 16:04:54 finalizer() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/util.py", line 224, in __call__ 2025-03-05 16:04:54 res = self._callback(*self._args, **self._kwargs) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/managers.py", line 871, in _decref 2025-03-05 16:04:54 dispatch(conn, None, 'decref', (token.id,)) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/managers.py", line 90, in dispatch 2025-03-05 16:04:54 kind, result = c.recv() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 250, in recv 2025-03-05 16:04:54 buf = self._recv_bytes() 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 414, in _recv_bytes 2025-03-05 16:04:54 buf = self._recv(4) 2025-03-05 16:04:54 File "/usr/lib/python3.10/multiprocessing/connection.py", line 379, in _recv 2025-03-05 16:04:54 chunk = read(handle, remaining) 2025-03-05 16:04:54 File "/usr/bin/clickhouse-test", line 366, in signal_handler 2025-03-05 16:04:54 raise Terminated(f"Terminated with {sig} signal") 2025-03-05 16:04:54 Terminated: Terminated with 15 signal 2025-03-05 16:04:54 Break tests execution 2025-03-05 16:04:54 Stopping tests